2015-02-05 - 16728 - Spec - Automate CFM to SNC #SNCProject #sncsup
SPECIFICATIONS 2015-02-05 Spec - Automate CFM to SNC
Purpose
Create a Program to Automate the CFM to SNC
Admin Info
Purpose
|
Create a Program to Automate the CFM to SNC
|
Requested By
|
Jeffery Mau
|
Spec Created By
|
Adithya, Damodhar
|
Spec Created Date
|
02/05/2015
|
Spec QA by
|
Adithya
|
Objects
|
ZSNC_ECC_MASTERDATA
|
Document Status
|
Complete
|
Estimates
Sl.No
|
Activity
|
Estimation in Hours
|
1
|
Research
|
50
|
2
|
Documentation
|
10
|
3
|
Development/ Config
|
40
|
4
|
Unit test in DEV
|
20
|
5
|
Unit test in QUA
|
|
6
|
Other activity
|
|
|
TOTAL
|
120
|
References
Prior Tickets
[Provide links of prior associated Spec / Break Fix BOSS document(s)]
SCM-Adithya-Venkat - 2015-01-30 - XXXX - Research - Automate the CFM1 Process to SNC - (Rahul by 2015-02-13)
Documents
[Attach any document(s) received for the requirement(s)]
Spec Changes
[List the changes made to program after the approval of the original requirement along with the Date on which the change request was received and the name of the initiator]
Con call on 02/24/2015:
- File Pattern SIM_ must be considered in the program
- Archive the files once these are processed fully.
- If any record form File 1 is failed to process the program shall consider the next file and process it.
- SPOOL: Log shall be displayed with the list of processed files successfully and unprocessed files & the error message must be displayed
Changes Freeze:
Sl.
|
Change Details
|
Requested By
|
Requested On
|
Notes if any
|
Approved
|
1
|
The program can be worked for one file having multiple vendors in it, and here is the revised estimate.
|
Jeff/Babu
|
02/27/2015
|
- Program shall be able to be processed with single file.
- Display log for the Failure Materials and the list of materials which are not processed.
- Archive the file after successful processing.
|
ABAP - 32 Hours
Testing - 12 Hours.
|
2
|
New Program to generate input file for CFM Program
|
Jeff/Babu
|
02/27/2015
|
- Input File for CFM Program which has to be placed in AL11
- Input file for Phase Master which must be placed in AL11.
|
Kept on Hold now
|
3
|
Phase Master program in SNC Sytem
|
Jeff/Babu
|
02/27/2015
|
- Change the program to read the files form APP Server and Archive.
SCM-Adithya-Damodar- 2015-03-11 - 16728 - Break fix - Automate Phase Master (Babu by 2015-03-19)
|
ABAP - 4 Hours
Testing - 2 Hours
|
Functional Requirement
Purpose/WHY:
[Explain the purpose of the project and the reason why this requirement has come]
Create a Program to facilitate automatic transfer of master data from ECC to SNC. The standard process provided by SAP is not working due to roll-over memory issue.
- A T Code must be assigned to the program (T Code: ZECC_SNC)
- The file which is used in the program must be archived after the usage -
(Which is currently not being done)
- A Folder in the directory must be created (/usr/sap/NEQ/SNC/CFM/)
In Scope:
[List the
activities to be included in scope]
Out of Scope:
[Out of scope activities]
Solution Summary
[Discuss this section with Requester and get approval prior to beginning work]
Create a custom program which shall create the Variant and execute program RIMODGEN which will create an Integration Model.
After Successful creation of Integration Model, the custom program shall call the Program RIMODAC2 which shall Activate the Integration Model.
After the Data is transferred (successful activation of Integration Model) the custom Program calls the program RIMODEL which deletes the previous inactive Integration Models which is created so as it must not effect the performance.
The input file contains Vendor, Plant, Material and Info Record Number as attached:
SIM_202666_1.txt
The Custom Program shall consider few (given as input) records of the file and process (If the file is with huge number of Records) and consider the next few materials and so on..
1. The Purchase Organization is hard coded as 0010
2. The vendor is considered form the first Row of the file: The input file must be vendor specific which means the each input file must be with one vendor only.
3. The File name shall be started with
SIM_Vendor (eg: SIM_202290.txt) which shall be placed in the AL11 SAP Directory.
(This is not done)
4. Creation of Integration Models Name:
Model Name : SNCIM.
Logical System : SNDCLNT100/ SNQCLNT100/ SNPCLNT100
APO Application: SIM_202290 (
Currently APO Application is Hard coded as IMPRG)
The APO Application will be the SIM_202290 (Starting 10 characters of the File) (
This is not done)
5. There is an option of splitting the file with number of records (Which is given as input).
Splitting Logic:
If the file is with multiple plants, the program sorts the file at plant and it considers the split given in the input and process CFM for those materials.
The Process Document with the Design is attached here:
Automate_CFM.docx
Test Plan
[List test scenarios/cases to be executed here]
Test ID
|
Test Scenario
|
Expected Results
|
SNCIM001
|
Run the Program with the flat file
|
An Integration Model must be created and Executed, Validate the Materials are transferred to SNC system with the transportation lane updated.
|
SNCIM002
|
Run the Program with the flat file with multiple plants in the file
|
An Integration Model must be created and Executed, Validate the Materials are transferred to SNC system with the transportation lane updated
|
Solution Details
[Provide complete technical details for configuration or programming here]
Create a program to do the Master data CFM to SNC.
Issues
[List Issues / Bugs identified in configuration or development]